Overview

Summary of Responsibilities:

Accountable for analyzing and developing complex logical database designs, logical data models and relational data definitions in support of corporate and customer information systems requirements. Understands the methodologies and technologies that depict the flow of data within and between technology systems and business functions/operations. Responsible for the identification and resolution of information flow, content issues and the transformation of business requirements into logical data models. This position identifies opportunities to reduce data redundancy, trends in data uses and single sources of data. Works under minimal supervision and is responsible to make a wide range of decisions, escalating to the manager when necessary and updating the manager on a regular basis.

Responsibilities

Position Responsibilities:

• Develop and maintain the Data-model Architecture across the Enterprise Business Intelligence (BI) program.

• Govern standards for data definitions and manipulation.

• Conduct interviews with business resources to gather requirements.

• Develop Technical Specifications and Mapping Documents.

• Lead ETL Developers in the development of data models and implementation of best practices.

• Senior resource for troubleshooting data model-related issues.

• Present data modeling topics to development teams, internal customers and leadership.

Qualifications

Selection Criteria:

• Proven knowledge of the financial services industry.

• Demonstrated knowledge of BI tools and methodologies. Must be able to cite examples of successful employment of BI tools and methods.

• Demonstrated knowledge of project management methodologies such as waterfall and Agile. Cite examples of successful project management engagements.

• Demonstrated experience with running queries and reports in a BI tool.

• Demonstrated experience with coding in SQL-based clients, such as PL/SQL, TOAD or similar applications.

• Proven knowledge of data modeling techniques. Must be able to cite examples comparing and contrasting Kimball approach versus Inmon versus data vault.

• Demonstrated experience in reducing data redundancy. Must be able to cite examples of successful projects reducing data redundancy and streamlining data models.

• Expertise in a (or multiple) CASE tools (ERwin, ORACLE Designer 2000, ER/Studio, etc.).

• Exposure to integration tools (DTS, SSIS, Informatica, Data Stage, etc.).

• Exposure to OLAP tools (Analysis Services, Cognos, BO, etc.).

• Exposure to Reporting tools (Reporting Services, Crystal Reports, etc.).

• Dependable team member.

Educational Requirements:

• Bachelor's degree or commensurate selection criteria experience.

Computer skills and knowledge of hardware & software required:

• Proficient in word processing, spreadsheets and database applications.

• Proficient in Oracle RDBMS and Microsoft SQL Server.

• Working knowledge of AIX, Windows and Linux Operating Systems including scripts and task scheduling.

• Working knowledge of Structured Query Language.

Certifications & licenses (i.e. Series 6 & 63, CPA, etc.):

• None required.

Position Demands:

• Extended hours required during peak workloads or special projects and to handle off-hours as required, including returning to work if necessary.